﻿CREATE TABLE [dbo].[Ry_Info] (
    [sfzh]       VARCHAR (18)  NOT NULL,
    [xm]         VARCHAR (10)  NULL,
    [xb]         BIT           NULL,
    [jg]         VARCHAR (15)  NULL,
    [gh]         VARCHAR (20)  NULL,
    [csrq]       DATETIME      NULL,
    [mz]         VARCHAR (10)  NULL,
    [ywpx]       BIT           NULL,
    [xl]         VARCHAR (10)  NULL,
    [zz]         VARCHAR (300) NULL,
    [lxdh]       VARCHAR (50)  NULL,
    [jjllr]      VARCHAR (30)  NULL,
    [lldh]       VARCHAR (50)  NULL,
    [xp]         VARCHAR (100) NULL,
    [gz1]        VARCHAR (100) NULL,
    [gz2]        VARCHAR (100) NULL,
    [gz3]        VARCHAR (100) NULL,
    [gz4]        VARCHAR (100) NULL,
    [gz5]        VARCHAR (100) NULL,
    [sfxyg]      BIT           NULL,
    [ygzt]       BIT           NULL,
    [sgz]        VARCHAR (50)  NULL,
    [jndj1]      VARCHAR (50)  NULL,
    [jndj2]      VARCHAR (50)  NULL,
    [jndj3]      VARCHAR (50)  NULL,
    [createtime] DATETIME      DEFAULT (getdate()) NULL,
    [htbh]       VARCHAR (50)  NULL,
    [xx]         VARCHAR (50)  NULL,
    [aqjycj]     VARCHAR (50)  NULL,
    [htyjpath]   VARCHAR (50)  NULL,
    [intime]     DATETIME      NULL,
    [outtime]    DATETIME      NULL,
    [pxhg]       BIT           DEFAULT ((0)) NULL,
    CONSTRAINT [PK_RY_INFO] PRIMARY KEY CLUSTERED ([sfzh] ASC)
);


GO
CREATE NONCLUSTERED INDEX [index_sfzh]
    ON [dbo].[Ry_Info]([sfzh] ASC);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0:退工 1：用工', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Ry_Info', @level2type = N'COLUMN', @level2name = N'ygzt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'1:新用工 0：非新用工', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Ry_Info', @level2type = N'COLUMN', @level2name = N'sfxyg';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'保存相片相对路径', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Ry_Info', @level2type = N'COLUMN', @level2name = N'xp';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0:无 1:有', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Ry_Info', @level2type = N'COLUMN', @level2name = N'ywpx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'记录所有人员基本信息', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Ry_Info';

